Skip Headers

Oracle® Database Backup and Recovery Reference 10g Release 2 (10.2) Part Number B14194-03 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# RC_PROXY_ARCHIVEDLOG

This view contains descriptions of archived log backups that were taken using the proxy copy functionality. It corresponds to the `V$PROXY_ARCHIVEDLOG` view.

In a proxy copy, the media manager takes over the operations of backing up and restoring data. Each row represents a backup of one control file.

Column | Datatype | Description
--- | --- | ---
`DB_KEY` | `NUMBER` | The primary key for the target database. Use this column to form a join with almost any other catalog view.
`DBINC_KEY` | `NUMBER` | The primary key for the incarnation of the target database. Use this column to form a join with `RC_DATABASE_INCARNATION`.
`DB_NAME` | `VARCHAR2(8)` | The `DB_NAME` of the database incarnation to which this record belongs.
`XAL_KEY` | `NUMBER` | The proxy copy primary key in the recovery catalog. If you issue the `LIST` command while connected to the recovery catalog, this value appears in the `KEY` column of the output.
`RECID` | `NUMBER` | The proxy copy record identifier from `V$PROXY_ARCHIVEDLOG.` `RECID` and `STAMP` form a concatenated primary key that uniquely identifies this record in the target database control file.
`STAMP` | `NUMBER` | The proxy copy stamp from`V$PROXY_ARCHIVEDLOG.` `RECID` and `STAMP` form a concatenated primary key that uniquely identifies this record in the target database control file.
`TAG` | `VARCHAR2(32)` | The tag for the proxy copy.
`DEVICE_TYPE` | `VARCHAR2(255)` | The type of media device that stores the proxy copy.
`HANDLE` | `VARCHAR2(1024)` | The name or "handle" for the proxy copy. RMAN passes this value to the operating system-dependent layer that identifies the file.
`COMMENTS` | `VARCHAR2(255)` | Comments about the proxy copy.
`MEDIA` | `VARCHAR2(80)` | A comment that contains further information about the media manager that created this backup.
`MEDIA_POOL` | `NUMBER` | The number of the media pool in which the proxy copy is stored.
`STATUS` | `VARCHAR2(1)` | The status of the backup set: `A` (available), `U` (unavailable), `X` (expired), or `D` (deleted).
`THREAD#` | `NUMBER` | The number of the redo thread.
`SEQUENCE#` | `NUMBER` | The log sequence number.
`RESETLOGS_CHANGE#` | `NUMBER` | The `RESETLOGS` SCN of the database incarnation to which this archived log belongs.
`RESETLOGS_TIME` | `DATE` | The `RESETLOGS` time stamp of the database incarnation to which this archived log belongs.
`FIRST_CHANGE#` | `NUMBER` | The first SCN of this redo log.
`FIRST_TIME` | `DATE` | The time when Oracle switched into the redo log.
`NEXT_CHANGE#` | `NUMBER` | The first SCN of the next redo log in the thread.
`NEXT_TIME` | `DATE` | The first time stamp of the next redo log in the thread.
`BLOCKS` | `NUMBER` | The size of this archived redo log in operating system blocks.
`BLOCK_SIZE` | `NUMBER` | The block size for the copy in bytes.
`DEVICE_TYPE` | `VARCHAR2(255)` | The type of sequential media device.
`START_TIME` | `DATE` | The time when proxy copy was initiated.
`COMPLETION_TIME` | `DATE` | The time when the proxy copy was completed.
`ELAPSED_SECONDS` | `NUMBER` | The duration of the proxy copy.